- add_stock_entries_payments.php
- project /
1 <?php
2 session_start(); // Use session variable on this page. This function must put on the top of page.
3 if(!isset($_SESSION['username']) || $_SESSION['usertype'] !='admin'){ // if session variable "username" does not exist.
4 header("location:index.php?msg=Please%20login%20to%20access%20admin%20area%20!"); // Re-direct to index.php
5 }
6 else
7 {
8 include_once "db.php";
9 error_reporting (E_ALL ^ E_NOTICE);
10
11 ?><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
12 "http://www.w3.org/TR/html4/loose.dtd">
13 <html>
14 <head>
15 <title>Welcome to Stock Management System !</title>
16 <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
17 <link rel="stylesheet" href="css/validationEngine.jquery.css" type="text/css" media="screen" title="no title" charset="utf-8" />
18 <link rel="stylesheet" href="css/template.css" type="text/css" media="screen" title="no title" charset="utf-8" />
19 <script src="js/jquery.min.js" type="text/javascript"></script>
20 <script type="text/javascript" src="jquery.date_input.js"></script>
21 <link rel="stylesheet" href="date_input.css" type="text/css">
22 <script type="text/javascript">$(function() {
23
24 $("#due").date_input();
25 });</script>
26
27
28 <script src="js/jquery.validationEngine-en.js" type="text/javascript"></script>
29 <script src="js/jquery.validationEngine.js" type="text/javascript"></script>
30 <script src="js/jquery.hotkeys-0.7.9.js"></script>
31 <!-- AJAX SUCCESS TEST FONCTION
32 <script>function callSuccessFunction(){alert("success executed")}
33 function callFailFunction(){alert("fail executed")}
34 </script>
35 -->
36
37 <script>
38
39
40 function balanceCalc()
41 { if(parseFloat($("#newpayment").val()) > parseFloat($("#balance").val()))
42 $("#newpayment").val(parseFloat($("#balance").val()));
43
44
45 }
46
47
48 $(document).ready(function() {
49 // SUCCESS AJAX CALL, replace "success: false," by: success : function() { callSuccessFunction() },
50 $("#name").focus();
51 $("#form1").validationEngine(),
52
53 jQuery(document).bind('keydown', 'Ctrl+s',function() {
54 $('#form1').submit();
55 return false;
56 });
57
58 jQuery(document).bind('keydown', 'Ctrl+r',function() {
59 $('#form1').reset();
60 return false;
61 });
62 jQuery(document).bind('keydown', 'Ctrl+a',function() {
63 window.location = "add_stock_entries_payments.php";
64 return false;
65 });
66 jQuery(document).bind('keydown', 'Ctrl+0',function() {
67 window.location = "admin.php";
68 return false;
69 });
70 jQuery(document).bind('keydown', 'Ctrl+1',function() {
71 window.location = "add_purchase.php";
72 return false;
73 });
74 jQuery(document).bind('keydown', 'Ctrl+2',function() {
75 window.location = "add_stock_sales.php";
76 return false;
77 });
78 jQuery(document).bind('keydown', 'Ctrl+3',function() {
79 window.location = "add_stock_details.php";
80 return false;
81 });
82 jQuery(document).bind('keydown', 'Ctrl+4',function() {
83 window.location = "add_category.php";
84 return false;
85 });
86 jQuery(document).bind('keydown', 'Ctrl+5',function() {
87 window.location = "add_supplier_details.php";
88 return false;
89 });
90 jQuery(document).bind('keydown', 'Ctrl+6',function() {
91 window.location = "add_customer_details.php";
92 return false;
93 });
94 jQuery(document).bind('keydown', 'Ctrl+7',function() {
95 window.location = "view_stock_entries.php";
96 return false;
97 });
98 jQuery(document).bind('keydown', 'Ctrl+8',function() {
99 window.location = "view_stock_sales.php";
100 return false;
101 });
102 jQuery(document).bind('keydown', 'Ctrl+9',function() {
103 window.location = "view_stock_details.php";
104 return false;
105 });
106 //$.validationEngine.loadValidation("#date")
107 //alert($("#formID").validationEngine({returnIsValid:true}))
108 //$.validationEngine.buildPrompt("#date","This is an example","error") // Exterior prompt build example // input prompt close example
109 //$.validationEngine.closePrompt(".formError",true) // CLOSE ALL OPEN PROMPTS
110 });
111 </script>
112 <style type="text/css">
113 <!--
114 body {
115 margin-left: 0px;
116 margin-top: 0px;
117 margin-right: 0px;
118 margin-bottom: 0px;
119 background-color: #FFFFFF;
120 }
121
122 *{
123 padding: 0px;
124 margin: 0px;
125 }
126 #vertmenu {
127 font-family: Verdana, Arial, Helvetica, sans-serif;
128 font-size: 100%;
129 width: 160px;
130 padding: 0px;
131 margin: 0px;
132 }
133
134 #vertmenu h1 {
135 display: block;
136 background-color:#FF9900;
137 font-size: 90%;
138 padding: 3px 0 5px 3px;
139 border: 1px solid #000000;
140 color: #333333;
141 margin: 0px;
142 width:159px;
143 }
144
145 #vertmenu ul {
146 list-style: none;
147 margin: 0px;
148 padding: 0px;
149 border: none;
150 }
151 #vertmenu ul li {
152 margin: 0px;
153 padding: 0px;
154 }
155 #vertmenu ul li a {
156 font-size: 80%;
157 display: block;
158 border-bottom: 1px dashed #C39C4E;
159 padding: 5px 0px 2px 4px;
160 text-decoration: none;
161 color: #666666;
162 width:160px;
163 }
164
165 #vertmenu ul li a:hover, #vertmenu ul li a:focus {
166 color: #000000;
167 background-color: #eeeeee;
168 }
169 .style1 {color: #000000}
170
171 -->
172 </style>
173 </head>
174
175 <body>
176 <table width="100%" border="0" cellspacing="0" cellpadding="0">
177 <tr>
178 <td align="center" valign="top"><table width="960" border="0" cellspacing="0" cellpadding="0">
179 <tr>
180 <td><table width="960" border="0" cellpadding="0" cellspacing="0" bgcolor="#ECECEC">
181 <tr>
182 <td height="90" align="left" valign="top"><img src="images/topbanner.jpg" width="960" height="82"></td>
183 </tr>
184 <tr>
185 <td height="800" align="left" valign="top"><table width="960" border="0" cellpadding="0" cellspacing="0" bgcolor="#ECECEC">
186 <tr>
187 <td width="130" align="left" valign="top">
188
189 <br>
190
191 <strong>Welcome <font color="#3399FF"><?php echo $_SESSION['username']; ?> !</font></strong><br> <br>
192 <table width="100%" border="0" cellspacing="0" cellpadding="0">
193 <tr>
194 <td align="center"><a href="admin.php"><img src="images/home.png" width="130" height="99" border="0"></a></td>
195 </tr>
196 <tr>
197 <td align="center"> </td>
198 </tr>
199 <tr>
200 <td align="center"><a href="add_purchase.php"><img src="images/purchase.png" width="130" height="124" border="0"></a></td>
201 </tr>
202 <tr>
203 <td align="center"> </td>
204 </tr>
205 <tr>
206 <td align="center"><a href="add_stock_sales.php"><img src="images/sales.png" width="146" height="111" border="0"></a></td>
207 </tr>
208 <tr>
209 <td align="center"> </td>
210 </tr>
211 <tr>
212 <td align="center"><a href="report.php"><img src="images/reports.png" width="131" height="142" border="0"></a></td>
213 </tr>
214 <tr>
215 <td align="center"> </td>
216 </tr>
217 <tr>
218 <td align="center"> </td>
219 </tr>
220 <tr>
221 <td align="center"> </td>
222 </tr>
223 </table>
224
225
226
227
228
229 </td> <td height="500" align="center" valign="top">
230 <table width="100%" border="0" cellspacing="0" cellpadding="0">
231 <tr>
232 <td><a href="add_stock_details.php"><img src="images/addstockdetails.png" width="67" height="62" border="0"></a></td>
233 <td><a href="add_supplier_details.php"><img src="images/supplier.png" width="67" height="54" border="0"></a></td>
234 <td><a href="add_customer_details.php"><img src="images/customer.png" width="67" height="54" border="0"></a></td>
235 <td><a href="add_category.php"><img src="images/categories.png" width="67" height="54" border="0"></a></td>
236 <td><a href="view_stock_sales.php"><img src="images/vsales.png" width="67" height="54" border="0"></a></td>
237 <td><a href="view_stock_entries.php"><img src="images/vpurchase.png" width="67" height="54" border="0"></a></td>
238 <td><a href="view_stock_details.php"><img src="images/stockdetails.png" width="67" height="54" border="0"></a></td>
239 <td><a href="view_stock_availability.php"><img src="images/savail.png" width="67" height="54" border="0"></a></td>
240 <td align="left" valign="top"><a href="view_customer_details.php"><img src="images/customers.png" width="94" height="22" border="0"></a><br> <a href="view_supplier_details.php"><img src="images/suppliers.png" width="94" height="22" border="0"></a><br>
241 <a href="view_payments.php"><img src="images/payments.png" width="94" height="22" border="0"></a></td>
242 <td align="left" valign="top"><a href="view_stock_sales_payments.php"><img src="images/outstanding.png" width="94" height="22" border="0"></a><br> <a href="view_stock_entries_payments.php"><img src="images/pendings.png" width="94" height="22" border="0"></a><br>
243 <a href="logout.php"><img src="images/logout.png" width="94" height="22" border="0"></a></td>
244 </tr>
245 </table>
246 <?php
247 if(isset($_POST['id']))
248
249 {
250
251 $id=mysql_real_escape_string($_POST['id']);
252 $balance=mysql_real_escape_string($_POST['balance']);
253 $payment=mysql_real_escape_string($_POST['payment']);
254 $supplier=mysql_real_escape_string($_POST['supplier']);
255 $subtotal=mysql_real_escape_string($_POST['subtotal']);
256 $newpayment=mysql_real_escape_string($_POST['newpayment']);
257 $selected_date=$_POST['due'];
258 $selected_date=strtotime( $selected_date );
259 $mysqldate = date( 'Y-m-d H:i:s', $selected_date );
260 $due=$mysqldate;
261 $balance= (int) $balance - (int) $newpayment;
262 $payment= (int) $payment + (int) $newpayment;
263
264 if($db->query("UPDATE stock_entries SET balance=$balance,payment=$payment,due='$due' where stock_id='$id'"))
265 {
266 $db->query("INSERT INTO transactions(type,supplier,payment,balance,rid,due,subtotal) values('entry','$supplier',$newpayment,$balance,'$id','$due',$subtotal)");
267 echo "<br><font color=green size=+1 > [ $id ] Supplier Details Updated!</font>" ;
268 }
269 else
270 echo "<br><font color=red size=+1 >Problem in Updation !</font>" ;
271
272
273 }
274
275 ?>
276
277 <br>
278 <br>
279
280 <?php
281 if(isset($_GET['eid']))
282 $id=$_GET['eid'];
283
284 $line = $db->queryUniqueObject("SELECT * FROM stock_entries WHERE stock_id='$id'");
285 ?>
286 <form name="form1" method="post" id="form1" action="">
287 <input name="id" type="hidden" value="<?php echo $_GET['eid']; ?>">
288 <input name="subtotal" type="hidden" value="<?php echo $line->subtotal; ?>">
289 <p align="center"><strong>Add Stock Supplier Payment </strong></p>
290 <table width="300" border="0" cellspacing="0" cellpadding="0">
291 <tr>
292 <td width="150"> </td>
293 <td width="150"> </td>
294 </tr>
295 <tr>
296 <td width="150"> </td>
297 <td width="150"> </td>
298 </tr>
299 <tr>
300 <td width="150"> </td>
301 <td width="150"> </td>
302 </tr>
303 <tr>
304 <td width="150">Stock Entry ID :</td>
305 <td width="150"><input name="eid" type="text" id="eid" value="<?php echo $line->stock_id; ?>" readonly=""></td>
306 </tr>
307 <tr>
308 <td width="150"> </td>
309 <td width="150"> </td>
310 </tr>
311 <tr>
312 <td width="150">Supplier:</td>
313 <td width="150"><input name="supplier" type="text" id="supplier" value="<?php echo $line->stock_supplier_name; ?>" readonly=""></td>
314 </tr>
315 <tr>
316 <td width="150"> </td>
317 <td width="150"> </td>
318 </tr>
319 <tr>
320 <td width="150">Total</td>
321 <td width="150"><input name="total" type="text" id="total" value="<?php echo $line->subtotal; ?>" readonly=""></td>
322 </tr>
323 <tr>
324 <td> </td>
325 <td> </td>
326 </tr>
327 <tr>
328 <td>Paid</td>
329 <td><input name="payment" type="text" id="payment" c value="<?php echo $line->payment;?>" readonly=""></td>
330 </tr>
331 <tr>
332 <td> </td>
333 <td> </td>
334 </tr>
335 <tr>
336 <td>Balance</td>
337 <td><input name="balance" type="text" id="balance" value="<?php echo $line->balance;?>" readonly=""></td>
338 </tr>
339 <tr>
340 <td> </td>
341 <td> </td>
342 </tr>
343 <tr>
344 <td>Next Due</td>
345 <td><input name="due" type="text" id="due" value="<?php
346
347 $phpdate = strtotime( $line->due );
348
349 $phpdate = date("d-m-Y",$phpdate);
350
351 echo $phpdate;
352 ?>" ></td>
353 </tr>
354 <tr>
355 <td> </td>
356 <td> </td>
357 </tr>
358 <tr>
359 <td>New Payment </td>
360 <td><input name="newpayment" type="text" id="newpayment" class="validate[optional,custom[onlyNumber],length[0,100]] text-input" value="" onKeyUp="balanceCalc()" ></td>
361 </tr>
362 <tr>
363 <td> </td>
364 <td> </td>
365 </tr>
366 <tr>
367 <td align="right"><input type="reset" name="Reset" value="Reset"> </td>
368 <td>
369 <input type="submit" name="Submit" value="Save"></td>
370 </tr>
371 <tr>
372 <td align="center"> (Control + R) </td>
373 <td align="left"> ( Control + S ) </td>
374 </tr>
375 </table>
376 </form>
377 <br>
378 <br>
379
380 </td>
381 </tr>
382 </table>
383
384 </td>
385 </tr>
386 <tr>
387 <td height="30" align="center" bgcolor="#72C9F4"><span class="style1"><a href="http://www.pluskb.com">Developed by PlusKB Innovations</a></span></td>
388 </tr>
389 </table></td>
390 </tr>
391 </table></td>
392 </tr>
393 </table>
394
395 </body>
396 </html>
397 <?php
398 }
399 ?>